//    Copyright (C) Kherty.  All rights reserved.
namespace OpenLS.Spreadsheet.Formats.Biff
{
    internal enum BuiltInFunctionId : ushort

    {
        Custom = 0xFF,
        COUNT = 0,
        ROUND = 27,
        IF = 1,
        LOOKUP = 28,
        ISNA = 2,
        INDEX = 29,
        ISERROR = 3,
        REPT = 30,
        SUM = 4,
        MID = 31,
        AVERAGE = 5,
        LEN = 32,
        MIN = 6,
        VALUE = 33,
        MAX = 7,
        TRUE = 34,
        ROW = 8,
        FALSE = 35,
        COLUMN = 9,
        AND = 36,

        NA = 10,
        OR = 37,

        NPV = 11,
        NOT = 38,
        STDEV = 12,
        MOD = 39,
        DOLLAR = 13,
        DCOUNT = 40,
        FIXED = 14,
        DSUM = 41,
        SIN = 15,
        DAVERAGE = 42,
        COS = 16,
        DMIN = 43,
        TAN = 17,
        DMAX = 44,
        ARCTAN = 18,
        DSTDEV = 45,
        PI = 19,
        VAR = 46,

        SQRT = 20,
        DVAR = 47,
        EXP = 21,
        TEXT = 48,
        LN = 22,
        LINEST = 49,
        LOG10 = 23,
        TREND9 = 50,
        ABS = 24,
        LOGEST = 51,
        INT = 25,
        GROWTH = 52,
        SIGN = 26,
        PV = 56,
        FV = 57,
        FIND = 124,
        NPER = 58,
        CELL = 125,
        PMT = 59,
        ISERR = 126,
        RATE = 60,
        ISTEXT = 127,
        MIRR = 61,
        ISNUMBER = 128,
        IRR = 62,
        ISBLANK = 129,
        RAND = 63,
        T = 130,
        MATCH = 64,
        N = 131,
        DATE = 65,
        DATEVALUE = 140,
        TIME = 66,
        TIMEVALUE = 141,
        DAY = 67,
        SLN = 142,
        MONTH = 68,
        SYD = 143,
        YEAR = 69,
        DDB = 144,
        WEEKDAY10 = 70,
        INDIRECT = 148,
        HOUR = 71,
        CLEAN = 162,
        MINUTE = 72,
        MDETERM = 163,
        SECOND = 73,
        MINVERSE = 164,
        NOW = 74,
        MMULT = 165,
        AREAS = 75,
        IPMT = 167,
        ROWS = 76,
        PPMT = 168,
        COLUMNS = 77,
        COUNTA = 169,

        OFFSET = 78,
        PRODUCT = 183,

        SEARCH = 82,
        FACT = 184,
        TRANSPOSE = 83,
        DPRODUCT = 191,
        TYPE = 86,
        ISNONTEXT = 192,
        ATAN2 = 97,
        STDEVP = 193,

        ASIN = 98,
        VARP = 194,

        ACOS = 99,
        DSTDEVP = 195,
        CHOOSE = 100,
        DVARP = 196,
        HLOOKUP = 101,
        TRUNC11 = 197,
        VLOOKUP = 102,
        ISLOGICAL = 198,
        ISREF = 105,
        DCOUNTA = 199,
        LOG = 109,
        USDOLLAR = 204,
        CHAR = 111,
        FINDB = 205,
        LOWER = 112,
        SEARCHB = 206,
        UPPER = 113,
        REPLACEB = 207,
        PROPER = 114,
        LEFTB = 208,
        LEFT = 115,
        RIGHTB = 209,
        RIGHT = 116,
        MIDB = 210,
        EXACT = 117,
        LENB = 211,
        TRIM = 118,
        ROUNDUP = 212,
        REPLACE = 119,
        ROUNDDOWN = 213,
        SUBSTITUTE = 120,
        ASC = 214,
        CODE = 121,
        DBSC = 215,
        //LINEST = 49,
        SUMPRODUCT = 228,

        TREND = 50,
        SINH = 229,
        //LOGEST = 51,
        COSH = 230,
        //GROWTH = 52,
        TANH = 231,
        TRUNC = 197,
        ASINH = 232,
        ADDRESS = 219,
        ACOSH = 233,
        DAYS360 = 220,
        ATANH = 234,
        TODAY = 221,
        DGET = 235,
        VDB = 222,
        INFO = 244,
        MEDIAN = 227,

        //FIXED = 14,
        PERMUT = 299,
        RANK = 216,
        POISSON = 300,
        DB = 247,
        TDIST = 301,
        FREQUENCY = 252,
        WEIBULL = 302,
        ERROR = 261,
        SUMXMY2 = 303,
        AVEDEV = 269,
        SUMX2MY2 = 304,
        BETADIST = 270,
        SUMX2PY2 = 305,
        GAMMALN = 271,
        CHITEST = 306,
        BETAINV = 272,
        CORREL = 307,
        BINOMDIST = 273,
        COVAR = 308,
        CHIDIST = 274,
        FORECAST = 309,
        CHIINV = 275,
        FTEST = 310,
        COMBIN = 276,
        INTERCEPT = 311,
        CONFIDENCE = 277,
        PEARSON = 312,
        CRITBINOM = 278,
        RSQ = 313,
        EVEN = 279,
        STEYX = 314,
        EXPONDIST = 280,
        SLOPE = 315,
        FDIST = 281,
        TTEST = 316,
        FINV = 282,
        PROB = 317,
        FISHER = 283,
        DEVSQ = 318,

        FISHERINV = 284,
        GEOMEAN = 319,

        FLOOR = 285,
        HARMEAN = 320,

        GAMMADIST = 286,
        SUMSQ = 321,

        GAMMAINV = 287,
        KURT = 322,

        CEILING = 288,
        SKEW = 323,

        HYPGEOMVERT = 289,
        ZTEST = 324,
        LOGNORMDIST = 290,
        LARGE = 325,
        LOGINV = 291,
        SMALL = 326,
        NEGBINOMDIST = 292,
        QUARTILE = 327,
        NORMDIST = 293,
        PERCENTILE = 328,
        NORMSDIST = 294,
        PERCENTRANK = 329,
        NORMINV = 295,
        MODE = 330,

        NORMSINV = 296,
        TRIMMEAN = 331,
        STANDARDIZE = 297,
        TINV = 332,
        ODD = 298,

        WEEKDAY = 70,
        SUMIF = 345,
        //HLOOKUP = 101,
        COUNTIF = 346,
        //VLOOKUP = 102,
        COUNTBLANK = 347,
        DAYS36015 = 220,
        ISPMT = 350,
        CONCATENATE = 336,
        DATEDIF = 351,
        POWER = 337,
        DATESTRING = 352,
        RADIANS = 342,
        NUMBERSTRING = 353,
        DEGREES = 343,
        ROMAN = 354,
        SUBTOTAL = 344,

        GETPIVOTDATA = 358,
        MINA = 363,

        HYPERLINK = 359,
        STDEVPA = 364,

        PHONETIC = 360,
        VARPA = 365,

        AVERAGEA = 361,
        STDEVA = 366,

        MAXA = 362,
        VARA = 367,
    }
}